package org.jeecg.modules.system.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;
import org.jeecg.modules.system.entity.*;

import java.util.List;

/**
 * @Description: 中科生产报表
 * @Author: jeecg-boot
 * @Date:   2024-07-26
 * @Version: V1.0
 */
public interface ZkProduceReportMapper extends BaseMapper<ZkProduceReport> {
    //根据车间，车间号查询夜班，中班，白班数据
    List<ZkProduceReport> queryZkProduceReportList(@Param("workshopName")String workshopName, @Param("mrpDsmBeginDate") String mrpDsmBeginDate, @Param("mrpDsmEndDate") String mrpDsmEndDate);

    //查询生产车间下得供料机
    List<ZkProduceReportPass> queryZkProduceReportPass(@Param("workshopName")String workshopName, @Param("mrpDsmBeginDate") String mrpDsmBeginDate);

    //月度显示，每个供料机近30天合格率柱状图
    List<ZkProduceReportWorkshopName> queryList(@Param("time")String time,@Param("workshopName")String workshopName);

    //月度显示，整个窑炉近30天合格率曲线图
    List<ZkProduceReportProductFloor>queryProductFloor(@Param("time")String time,@Param("workshopName") String workshopName);

    //近三个班供料机合格率
    List<ZkProduceReportGlcname> queryGlcname(@Param("workshopName")String workshopName, @Param("mrpDsmBeginDate") String mrpDsmBeginDate, @Param("mrpDsmEndDate") String mrpDsmEndDate);
}
